<!DOCTYPE html>
<html lang="en" class="svg no-js">
<head>
    <meta charset="utf-8" />
    <!--[if IE ]>
    <meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1" />
    <![endif]-->
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="Language" content="en">

    <title>MySQL :: MySQL 8.0 Reference Manual :: 9.3 Keywords and Reserved Words</title>
    <link rel="stylesheet" media="all" href="css/main-20190125.min.css" />
            <link rel="stylesheet" media="all" href="css/docs-20190125.min.css" />
    
    
    <link rel="stylesheet" media="print" href="css/print-20190125.min.css" />

    
    
    
    
            <link rel="contents" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="start" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="prev" href="function-resolution.html" title="9.2.4 Function Name Parsing and Resolution" />
<link rel="next" href="user-variables.html?ff=nopfpls" title="9.4 User-Defined Variables" />
<link rel="up" href="language-structure.html" title="9 Language Structure" />

    
    <link rel="shortcut icon" href="favicon.ico" />
    <script>(function(H){ H.className=H.className.replace(/\bno-js\b/,'js') })(document.documentElement)</script>
    <script src="js/site-20181120.min.js"></script>

    
    
    
    <!--[if lt IE 9]>
        <script src="https://labs.mysql.com/common/js/polyfills/html5shiv-printshiv-3.7.2.min.js"></script>
        <script src="https://labs.mysql.com/common/js/polyfills/respond-1.4.2.min.js"></script>
    <![endif]-->
        <!--[if IE 9]>
        <style>#docs-sidebar-toc { box-sizing: content-box; }</style>
    <![endif]-->
    </head>

<body class="no-sidebar full-page dev">
<div class="page-wrapper">
    <header>

                        <a href="https://dev.mysql.com/" aria-label="Home" title="MySQL" id="l1-home-link"></a>
        
        <div id="l1-nav-container">
            <div id="l1-line1">
                <div id="l1-auth-links">
                    <a href="https://www.mysql.com/about/contact/"><b>Contact MySQL</b></a>
                    <span id="l1-contact-separator">&nbsp;|&nbsp;</span>
                    <span id="l1-contact-separator-br"><br /></span>
                                             <a href="https://dev.mysql.com/auth/login/?dest=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fkeywords.html">Login</a> &nbsp;|&nbsp;
                         <a href="https://dev.mysql.com/auth/register/">Register</a>
                                    </div>
                <div id="l1-lhs">
                    <div id="l1-slogan">
                        The world's most popular open source database
                    </div>
                    <div id="l1-search-box">
                        <form id="l1-search-form" method="get" action="https://www.oracle.com/search/results">
                        <input type="hidden" name="cat" value="mysql" />
                        <input type="hidden" name="Ntk" value="SI-ALL5" />
                        <input id="l1-search-input" type="search" class="icon-search" placeholder="Search" aria-label="Search" name="Ntt" />
                        </form>
                    </div>
                </div>
            </div>
            <div id="l1-line2">
                <div class="social-icons">
                    <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook"></span></a>
                    <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter"></span></a>
                    <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin"></span></a>
                    <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube"></span></a>
                </div>
                <ul id="l1-nav">
                    <li>
                        <a href="https://www.mysql.com/"><!-- <span class="icon-sakila"></span>  -->MySQL.com</a>
                    </li><li>
                        <a href="https://www.mysql.com/downloads/"><!-- <span class="icon-download-thin"></span>  -->Downloads</a>
                    </li><li class="active">
                        <a href="/doc/"><!-- <span class="icon-books"></span>  -->Documentation</a>
                    </li><li>
                        <a href="/"><!-- <span class="icon-code"></span>  -->Developer Zone</a>
                    </li>                </ul>
            </div>
        </div>
        <div id="sub-header">
            <div id="l2-nav-container">
                <div id="l2-nav-toggle">
                    <span class="icon-three-bars"></span>
                </div>
                                                                                        <a class="button nav-button-3" href="/"><span class="icon-code"></span> Developer Zone</a>
                                                                                                                                    <a class="button nav-button-2" href="https://www.mysql.com/downloads/"><span class="icon-download-thin"></span> Downloads</a>
                                                                                                <a class="button nav-button-1" href="https://www.mysql.com/"><span class="icon-sakila"></span> MySQL.com</a>
                                                                        <div id="l2-search-toggle">
                    <span class="icon-search"></span>
                </div>
                <div id="l2-site-icon">
                                                                                                                                                                                                    <span class="icon-books"></span>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        </div>
                <div id="l1-section-title">
                    <span id="l1-section-label">
                        <a href="/doc/">Documentation</a>
                    </span>
                </div>
                <nav>
                    

<ul id="l2-nav">
            	<li class="active"><a class="active " href="/doc/refman/en/">MySQL Server</a>
    			</li>
	        	<li class=""><a  href="/doc/index-enterprise.html">MySQL Enterprise</a>
    			</li>
	        	<li class=""><a  href="/doc/workbench/en/">Workbench</a>
    			</li>
	        	<li class=""><a  href="/doc/en/mysql-innodb-cluster-userguide.html">InnoDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-cluster.html">MySQL NDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-connectors.html">Connectors</a>
    			</li>
	        	<li class=" last"><a  href="/doc/index-other.html">More</a>
    			</li>
	                        <li class="other-section"><a href="https://www.mysql.com/">MySQL.com</a></li>
                            <li class="other-section"><a href="https://www.mysql.com/downloads/">Downloads</a></li>
                                        <li class="other-section"><a href="/">Developer Zone</a></li>
            </ul>
                </nav>
            </div>
            <div id="l3-search-container"></div>
            <div id="top-orange"><span id="section-nav">Section Menu: &nbsp; </span></div>
        </div>
    </header>
        <div id="page">
                        <div role="main" id="main">

            
                
            
<div>
    <div id="docs-sidebar-toc" class="">
    <div id="docs-toc-inner">
        <div class="docs-sidebar-header" id="docs-nav-header">
            <a class="docs-show-hide-nav" id="docs-hide-nav" href="" title="Hide Sidebar" aria-label="Hide Sidebar"><span class="icon-arrow-small-left"></span></a>
            <div class="docs-nav-links">
                                    
    <a href="function-resolution.html"
        aria-label="Previous" title="Previous: Function Name Parsing and Resolution"><span
        class="icon-chevron-left"></span></a>
<a href="index.html" aria-label="Start" title="Start"><span class="icon-book-open"></span></a>
        <a aria-label="Up" href="language-structure.html" title="Up: Language Structure"><span class="icon-chevron-up"></span></a>
    <a href="user-variables.html" aria-label="Next"
        title="Next: User-Defined Variables"><span
        class="icon-chevron-right"></span></a>
                            </div>
        </div>
                    
<div id="docs-sidebar-search-container">
    <div id="docs-sidebar-search-box">
        <form method="get" action="/mysql-manual/search-page">
            <input type="hidden" name="d" id="d" value="201" />
            <input type="hidden" name="p" id="p" value="1" />
            <input type="text" name="keyword" id="q" title="Search this Manual"
                value=""
                style="color: #bbb;"
                onfocus=""
                onblur="" />

            <button class="docs-sidebar-search-btn" aria-label="Search" title="Search" type="submit">
                <span class="icon-search"></span>
            </button>
        </form>
    </div>
</div>
                <div class="docs-sidebar-nav">
            <a class="docs-icon-home" href="/doc/"><span class="icon-home"></span>Documentation Home</a><hr />
            <div class="docs-sidebar-mtitle">MySQL 8.0 Reference Manual</div>
            <nav class="doctoc" id="doc-201">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="preface.html">Preface and Legal Notices</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="introduction.html">General Information</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="installing.html">Installing and Upgrading MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="tutorial.html">Tutorial</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs.html">MySQL Programs</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="server-administration.html">MySQL Server Administration</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="security.html">Security</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="backup-and-recovery.html">Backup and Recovery</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="optimization.html">Optimization</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-down"></span></a></div><div class="docs-sidebar-nav-link"><a href="language-structure.html">Language Structure</a></div></div>                        <div class="docs-submenu">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="literals.html">Literal Values</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="string-literals.html">String Literals</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="number-literals.html">Numeric Literals</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="date-and-time-literals.html">Date and Time Literals</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="hexadecimal-literals.html">Hexadecimal Literals</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="bit-value-literals.html">Bit-Value Literals</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="boolean-literals.html">Boolean Literals</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="null-values.html">NULL Values</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="identifiers.html">Schema Object Names</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="identifier-qualifiers.html">Identifier Qualifiers</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="identifier-case-sensitivity.html">Identifier Case Sensitivity</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="identifier-mapping.html">Mapping of Identifiers to File Names</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="function-resolution.html">Function Name Parsing and Resolution</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link current"><a href="keywords.html">Keywords and Reserved Words</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="user-variables.html">User-Defined Variables</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="expressions.html">Expressions</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="comments.html">Comment Syntax</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="charset.html">Character Sets, Collations, Unicode</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-types.html">Data Types</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="functions.html">Functions and Operators</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sql-syntax.html">SQL Statement Syntax</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-dictionary.html">MySQL Data Dictionary</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="innodb-storage-engine.html">The InnoDB Storage Engine</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="storage-engines.html">Alternative Storage Engines</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="replication.html">Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="group-replication.html">Group Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-shell-userguide.html">MySQL Shell</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="document-store.html">Using MySQL as a Document Store</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-innodb-cluster-userguide.html">InnoDB Cluster</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-cluster.html">MySQL NDB Cluster 8.0</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="partitioning.html">Partitioning</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="stored-objects.html">Stored Objects</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="information-schema.html">INFORMATION_SCHEMA Tables</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="performance-schema.html">MySQL Performance Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sys-schema.html">MySQL sys Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="connectors-apis.html">Connectors and APIs</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="extending-mysql.html">Extending MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-enterprise.html">MySQL Enterprise Edition</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="workbench.html">MySQL Workbench</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="faqs.html">MySQL 8.0 Frequently Asked Questions</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="error-handling.html">Errors, Error Codes, and Common Problems</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="restrictions.html">Restrictions and Limits</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="indexes.html">Indexes</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="glossary.html">MySQL Glossary</a></div></div>                    </li>
        </ul>
                            </nav>
        </div>

        
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian open">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian open">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>

        <br /><span id="wkr"><br /></span>
    </div>
    </div>

    <div id="docs-main" class="has-toc">
    <div id="docs-main-inner">

                <div class="right" id="docs-version-nav">
            <a href="" id="docs-version-nav-toggle">version 8.0
            <span class="icon-chevron-down"></span></a>
            <div id="docs-version-list">
                                                                                            <a                         href="/doc/refman/5.7/en/keywords.html">
                        5.7
                                            </a><br />
                                                                            <a                         href="/doc/refman/5.6/en/keywords.html">
                        5.6
                                            </a><br />
                                                                            <a                         href="/doc/refman/5.5/en/keywords.html">
                        5.5
                                            </a><br />
                                                                        <div id="docs-version-nav-lang">
                                                                                                                                                    <a                                     class="tooltip-left"
                                    data-tooltip="The page you are viewing does not exist in version
                                    5.6 (JA).
                                    This link will take you to the Table of Contents."
                                                                        href="/doc/refman/5.6/ja/">
                                    5.6&nbsp;
                                                                            Japanese
                                                                    </a><br />
                                                                                            </div>
                            </div>
        </div>
        
        <div id="docs-show-nav" class="left hidden" style="margin-right: 15px;">
            <a class="docs-show-hide-nav" href="" aria-label="Show Sidebar"
                title="Show Sidebar"><span class="icon-arrow-small-right"></span></a>
        </div>

                        <div id="docs-breadcrumbs">
            <a href="/doc/refman/8.0/en/">MySQL 8.0 Reference Manual</a> &nbsp;/&nbsp;
                                                        <a href="language-structure.html">Language Structure</a> &nbsp;/&nbsp;
                                                                                    Keywords and Reserved Words
                                    </div>
        
        <div id="docs-body">
        
<div class="section">
<div class="titlepage">
<div>
<div>
<h2 class="title"><a name="keywords"></a>9.3 Keywords and Reserved Words</h2>

</div>

</div>

</div>
<a class="indexterm" name="idm139663206201904"></a><a class="indexterm" name="idm139663206200864"></a><p>
      Keywords are words that have significance in SQL. Certain
      keywords, such as <a class="link" href="select.html" title="13.2.10 SELECT Syntax"><code class="literal">SELECT</code></a>,
      <a class="link" href="delete.html" title="13.2.2 DELETE Syntax"><code class="literal">DELETE</code></a>, or
      <a class="link" href="integer-types.html" title="11.2.1 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT"><code class="literal">BIGINT</code></a>, are reserved and require
      special treatment for use as identifiers such as table and column
      names. This may also be true for the names of built-in functions.
    </p><p>
      Nonreserved keywords are permitted as identifiers without quoting.
      Reserved words are permitted as identifiers if you quote them as
      described in <a class="xref" href="identifiers.html" title="9.2 Schema Object Names">Section 9.2, “Schema Object Names”</a>:
    </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; CREATE TABLE interval (begin INT, end INT);
ERROR 1064 (42000): You have an error in your SQL syntax ...
near 'interval (begin INT, end INT)'</code></pre><p>
      <code class="literal">BEGIN</code> and <code class="literal">END</code> are keywords
      but not reserved, so their use as identifiers does not require
      quoting. <code class="literal">INTERVAL</code> is a reserved keyword and
      must be quoted to be used as an identifier:
    </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; CREATE TABLE `interval` (begin INT, end INT);
Query OK, 0 rows affected (0.01 sec)</code></pre><p>
      Exception: A word that follows a period in a qualified name must
      be an identifier, so it need not be quoted even if it is reserved:
    </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; CREATE TABLE mydb.interval (begin INT, end INT);
Query OK, 0 rows affected (0.01 sec)</code></pre><p>
      Names of built-in functions are permitted as identifiers but may
      require care to be used as such. For example,
      <code class="literal">COUNT</code> is acceptable as a column name. However,
      by default, no whitespace is permitted in function invocations
      between the function name and the following <code class="literal">(</code>
      character. This requirement enables the parser to distinguish
      whether the name is used in a function call or in nonfunction
      context. For further details on recognition of function names, see
      <a class="xref" href="function-resolution.html" title="9.2.4 Function Name Parsing and Resolution">Section 9.2.4, “Function Name Parsing and Resolution”</a>.
    </p><p>
      The <code class="literal">INFORMATION_SCHEMA.KEYWORDS</code> table lists the
      words considered keywords by MySQL and indicates whether they are
      reserved. See <a class="xref" href="keywords-table.html" title="25.14 The INFORMATION_SCHEMA KEYWORDS Table">Section 25.14, “The INFORMATION_SCHEMA KEYWORDS Table”</a>.
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><a class="xref" href="keywords.html#keywords-in-current-series" title="MySQL 8.0 Keywords and Reserved Words">MySQL 8.0 Keywords and Reserved Words</a></p></li><li class="listitem"><p><a class="xref" href="keywords.html#keywords-new-in-current-series" title="MySQL 8.0 New Keywords and Reserved Words">MySQL 8.0 New Keywords and Reserved Words</a></p></li><li class="listitem"><p><a class="xref" href="keywords.html#keywords-removed-in-current-series" title="MySQL 8.0 Removed Keywords and Reserved Words">MySQL 8.0 Removed Keywords and Reserved Words</a></p></li></ul>
</div>

<div class="simplesect">

<div class="titlepage">
<div>

<div class="simple">
<h3 class="title"><a name="keywords-in-current-series"></a>MySQL 8.0 Keywords and Reserved Words</h3>

</div>

</div>

</div>
<p>
        The following list shows the keywords and reserved words in
        MySQL 8.0, along with changes to individual words
        from version to version. Reserved keywords are marked with (R).
        In addition, <code class="literal">_FILENAME</code> is reserved.
      </p><p>
        At some point, you might upgrade to a higher version, so it is a
        good idea to have a look at future reserved words, too. You can
        find these in the manuals that cover higher versions of MySQL.
        Most of the reserved words in the list are forbidden by standard
        SQL as column or table names (for example,
        <code class="literal">GROUP</code>). A few are reserved because MySQL
        needs them and uses a <span class="command"><strong>yacc</strong></span> parser.
      </p><p><a name="keywords-8-0-detailed-top"></a><a class="link" href="keywords.html#keywords-8-0-detailed-A">A</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-B">B</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-C">C</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-D">D</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-E">E</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-F">F</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-G">G</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-H">H</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-I">I</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-J">J</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-K">K</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-L">L</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-M">M</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-N">N</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-O">O</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-P">P</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-Q">Q</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-R">R</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-S">S</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-T">T</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-U">U</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-V">V</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-W">W</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-X">X</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-Y">Y</a>
 | <a class="link" href="keywords.html#keywords-8-0-detailed-Z">Z</a>
</p><p><a name="keywords-8-0-detailed-A"></a>A</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">ACCESSIBLE</code> (R)</p></li><li class="listitem"><p><code class="literal">ACCOUNT</code></p></li><li class="listitem"><p><code class="literal">ACTION</code></p></li><li class="listitem"><p><code class="literal">ACTIVE</code>; added in 8.0.14 (nonreserved)</p></li><li class="listitem"><p><code class="literal">ADD</code> (R)</p></li><li class="listitem"><p><code class="literal">ADMIN</code>; became nonreserved in 8.0.12</p></li><li class="listitem"><p><code class="literal">AFTER</code></p></li><li class="listitem"><p><code class="literal">AGAINST</code></p></li><li class="listitem"><p><code class="literal">AGGREGATE</code></p></li><li class="listitem"><p><code class="literal">ALGORITHM</code></p></li><li class="listitem"><p><code class="literal">ALL</code> (R)</p></li><li class="listitem"><p><code class="literal">ALTER</code> (R)</p></li><li class="listitem"><p><code class="literal">ALWAYS</code></p></li><li class="listitem"><p><code class="literal">ANALYSE</code>; removed in 8.0.1</p></li><li class="listitem"><p><code class="literal">ANALYZE</code> (R)</p></li><li class="listitem"><p><code class="literal">AND</code> (R)</p></li><li class="listitem"><p><code class="literal">ANY</code></p></li><li class="listitem"><p><code class="literal">ARRAY</code> (R); added in 8.0.17 (reserved)</p></li><li class="listitem"><p><code class="literal">AS</code> (R)</p></li><li class="listitem"><p><code class="literal">ASC</code> (R)</p></li><li class="listitem"><p><code class="literal">ASCII</code></p></li><li class="listitem"><p><code class="literal">ASENSITIVE</code> (R)</p></li><li class="listitem"><p><code class="literal">AT</code></p></li><li class="listitem"><p><code class="literal">AUTOEXTEND_SIZE</code></p></li><li class="listitem"><p><code class="literal">AUTO_INCREMENT</code></p></li><li class="listitem"><p><code class="literal">AVG</code></p></li><li class="listitem"><p><code class="literal">AVG_ROW_LENGTH</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-B"></a>B</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">BACKUP</code></p></li><li class="listitem"><p><code class="literal">BEFORE</code> (R)</p></li><li class="listitem"><p><code class="literal">BEGIN</code></p></li><li class="listitem"><p><code class="literal">BETWEEN</code> (R)</p></li><li class="listitem"><p><code class="literal">BIGINT</code> (R)</p></li><li class="listitem"><p><code class="literal">BINARY</code> (R)</p></li><li class="listitem"><p><code class="literal">BINLOG</code></p></li><li class="listitem"><p><code class="literal">BIT</code></p></li><li class="listitem"><p><code class="literal">BLOB</code> (R)</p></li><li class="listitem"><p><code class="literal">BLOCK</code></p></li><li class="listitem"><p><code class="literal">BOOL</code></p></li><li class="listitem"><p><code class="literal">BOOLEAN</code></p></li><li class="listitem"><p><code class="literal">BOTH</code> (R)</p></li><li class="listitem"><p><code class="literal">BTREE</code></p></li><li class="listitem"><p><code class="literal">BUCKETS</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">BY</code> (R)</p></li><li class="listitem"><p><code class="literal">BYTE</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-C"></a>C</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">CACHE</code></p></li><li class="listitem"><p><code class="literal">CALL</code> (R)</p></li><li class="listitem"><p><code class="literal">CASCADE</code> (R)</p></li><li class="listitem"><p><code class="literal">CASCADED</code></p></li><li class="listitem"><p><code class="literal">CASE</code> (R)</p></li><li class="listitem"><p><code class="literal">CATALOG_NAME</code></p></li><li class="listitem"><p><code class="literal">CHAIN</code></p></li><li class="listitem"><p><code class="literal">CHANGE</code> (R)</p></li><li class="listitem"><p><code class="literal">CHANGED</code></p></li><li class="listitem"><p><code class="literal">CHANNEL</code></p></li><li class="listitem"><p><code class="literal">CHAR</code> (R)</p></li><li class="listitem"><p><code class="literal">CHARACTER</code> (R)</p></li><li class="listitem"><p><code class="literal">CHARSET</code></p></li><li class="listitem"><p><code class="literal">CHECK</code> (R)</p></li><li class="listitem"><p><code class="literal">CHECKSUM</code></p></li><li class="listitem"><p><code class="literal">CIPHER</code></p></li><li class="listitem"><p><code class="literal">CLASS_ORIGIN</code></p></li><li class="listitem"><p><code class="literal">CLIENT</code></p></li><li class="listitem"><p><code class="literal">CLONE</code>; added in 8.0.3 (nonreserved)</p></li><li class="listitem"><p><code class="literal">CLOSE</code></p></li><li class="listitem"><p><code class="literal">COALESCE</code></p></li><li class="listitem"><p><code class="literal">CODE</code></p></li><li class="listitem"><p><code class="literal">COLLATE</code> (R)</p></li><li class="listitem"><p><code class="literal">COLLATION</code></p></li><li class="listitem"><p><code class="literal">COLUMN</code> (R)</p></li><li class="listitem"><p><code class="literal">COLUMNS</code></p></li><li class="listitem"><p><code class="literal">COLUMN_FORMAT</code></p></li><li class="listitem"><p><code class="literal">COLUMN_NAME</code></p></li><li class="listitem"><p><code class="literal">COMMENT</code></p></li><li class="listitem"><p><code class="literal">COMMIT</code></p></li><li class="listitem"><p><code class="literal">COMMITTED</code></p></li><li class="listitem"><p><code class="literal">COMPACT</code></p></li><li class="listitem"><p><code class="literal">COMPLETION</code></p></li><li class="listitem"><p><code class="literal">COMPONENT</code></p></li><li class="listitem"><p><code class="literal">COMPRESSED</code></p></li><li class="listitem"><p><code class="literal">COMPRESSION</code></p></li><li class="listitem"><p><code class="literal">CONCURRENT</code></p></li><li class="listitem"><p><code class="literal">CONDITION</code> (R)</p></li><li class="listitem"><p><code class="literal">CONNECTION</code></p></li><li class="listitem"><p><code class="literal">CONSISTENT</code></p></li><li class="listitem"><p><code class="literal">CONSTRAINT</code> (R)</p></li><li class="listitem"><p><code class="literal">CONSTRAINT_CATALOG</code></p></li><li class="listitem"><p><code class="literal">CONSTRAINT_NAME</code></p></li><li class="listitem"><p><code class="literal">CONSTRAINT_SCHEMA</code></p></li><li class="listitem"><p><code class="literal">CONTAINS</code></p></li><li class="listitem"><p><code class="literal">CONTEXT</code></p></li><li class="listitem"><p><code class="literal">CONTINUE</code> (R)</p></li><li class="listitem"><p><code class="literal">CONVERT</code> (R)</p></li><li class="listitem"><p><code class="literal">CPU</code></p></li><li class="listitem"><p><code class="literal">CREATE</code> (R)</p></li><li class="listitem"><p><code class="literal">CROSS</code> (R)</p></li><li class="listitem"><p><code class="literal">CUBE</code> (R); became reserved in 8.0.1</p></li><li class="listitem"><p><code class="literal">CUME_DIST</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">CURRENT</code></p></li><li class="listitem"><p><code class="literal">CURRENT_DATE</code> (R)</p></li><li class="listitem"><p><code class="literal">CURRENT_TIME</code> (R)</p></li><li class="listitem"><p><code class="literal">CURRENT_TIMESTAMP</code> (R)</p></li><li class="listitem"><p><code class="literal">CURRENT_USER</code> (R)</p></li><li class="listitem"><p><code class="literal">CURSOR</code> (R)</p></li><li class="listitem"><p><code class="literal">CURSOR_NAME</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-D"></a>D</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">DATA</code></p></li><li class="listitem"><p><code class="literal">DATABASE</code> (R)</p></li><li class="listitem"><p><code class="literal">DATABASES</code> (R)</p></li><li class="listitem"><p><code class="literal">DATAFILE</code></p></li><li class="listitem"><p><code class="literal">DATE</code></p></li><li class="listitem"><p><code class="literal">DATETIME</code></p></li><li class="listitem"><p><code class="literal">DAY</code></p></li><li class="listitem"><p><code class="literal">DAY_HOUR</code> (R)</p></li><li class="listitem"><p><code class="literal">DAY_MICROSECOND</code> (R)</p></li><li class="listitem"><p><code class="literal">DAY_MINUTE</code> (R)</p></li><li class="listitem"><p><code class="literal">DAY_SECOND</code> (R)</p></li><li class="listitem"><p><code class="literal">DEALLOCATE</code></p></li><li class="listitem"><p><code class="literal">DEC</code> (R)</p></li><li class="listitem"><p><code class="literal">DECIMAL</code> (R)</p></li><li class="listitem"><p><code class="literal">DECLARE</code> (R)</p></li><li class="listitem"><p><code class="literal">DEFAULT</code> (R)</p></li><li class="listitem"><p><code class="literal">DEFAULT_AUTH</code></p></li><li class="listitem"><p><code class="literal">DEFINER</code></p></li><li class="listitem"><p><code class="literal">DEFINITION</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">DELAYED</code> (R)</p></li><li class="listitem"><p><code class="literal">DELAY_KEY_WRITE</code></p></li><li class="listitem"><p><code class="literal">DELETE</code> (R)</p></li><li class="listitem"><p><code class="literal">DENSE_RANK</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">DESC</code> (R)</p></li><li class="listitem"><p><code class="literal">DESCRIBE</code> (R)</p></li><li class="listitem"><p><code class="literal">DESCRIPTION</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">DES_KEY_FILE</code>; removed in 8.0.3</p></li><li class="listitem"><p><code class="literal">DETERMINISTIC</code> (R)</p></li><li class="listitem"><p><code class="literal">DIAGNOSTICS</code></p></li><li class="listitem"><p><code class="literal">DIRECTORY</code></p></li><li class="listitem"><p><code class="literal">DISABLE</code></p></li><li class="listitem"><p><code class="literal">DISCARD</code></p></li><li class="listitem"><p><code class="literal">DISK</code></p></li><li class="listitem"><p><code class="literal">DISTINCT</code> (R)</p></li><li class="listitem"><p><code class="literal">DISTINCTROW</code> (R)</p></li><li class="listitem"><p><code class="literal">DIV</code> (R)</p></li><li class="listitem"><p><code class="literal">DO</code></p></li><li class="listitem"><p><code class="literal">DOUBLE</code> (R)</p></li><li class="listitem"><p><code class="literal">DROP</code> (R)</p></li><li class="listitem"><p><code class="literal">DUAL</code> (R)</p></li><li class="listitem"><p><code class="literal">DUMPFILE</code></p></li><li class="listitem"><p><code class="literal">DUPLICATE</code></p></li><li class="listitem"><p><code class="literal">DYNAMIC</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-E"></a>E</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">EACH</code> (R)</p></li><li class="listitem"><p><code class="literal">ELSE</code> (R)</p></li><li class="listitem"><p><code class="literal">ELSEIF</code> (R)</p></li><li class="listitem"><p><code class="literal">EMPTY</code> (R); added in 8.0.4 (reserved)</p></li><li class="listitem"><p><code class="literal">ENABLE</code></p></li><li class="listitem"><p><code class="literal">ENCLOSED</code> (R)</p></li><li class="listitem"><p><code class="literal">ENCRYPTION</code></p></li><li class="listitem"><p><code class="literal">END</code></p></li><li class="listitem"><p><code class="literal">ENDS</code></p></li><li class="listitem"><p><code class="literal">ENFORCED</code>; added in 8.0.16 (nonreserved)</p></li><li class="listitem"><p><code class="literal">ENGINE</code></p></li><li class="listitem"><p><code class="literal">ENGINES</code></p></li><li class="listitem"><p><code class="literal">ENUM</code></p></li><li class="listitem"><p><code class="literal">ERROR</code></p></li><li class="listitem"><p><code class="literal">ERRORS</code></p></li><li class="listitem"><p><code class="literal">ESCAPE</code></p></li><li class="listitem"><p><code class="literal">ESCAPED</code> (R)</p></li><li class="listitem"><p><code class="literal">EVENT</code></p></li><li class="listitem"><p><code class="literal">EVENTS</code></p></li><li class="listitem"><p><code class="literal">EVERY</code></p></li><li class="listitem"><p><code class="literal">EXCEPT</code> (R)</p></li><li class="listitem"><p><code class="literal">EXCHANGE</code></p></li><li class="listitem"><p><code class="literal">EXCLUDE</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">EXECUTE</code></p></li><li class="listitem"><p><code class="literal">EXISTS</code> (R)</p></li><li class="listitem"><p><code class="literal">EXIT</code> (R)</p></li><li class="listitem"><p><code class="literal">EXPANSION</code></p></li><li class="listitem"><p><code class="literal">EXPIRE</code></p></li><li class="listitem"><p><code class="literal">EXPLAIN</code> (R)</p></li><li class="listitem"><p><code class="literal">EXPORT</code></p></li><li class="listitem"><p><code class="literal">EXTENDED</code></p></li><li class="listitem"><p><code class="literal">EXTENT_SIZE</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-F"></a>F</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">FALSE</code> (R)</p></li><li class="listitem"><p><code class="literal">FAST</code></p></li><li class="listitem"><p><code class="literal">FAULTS</code></p></li><li class="listitem"><p><code class="literal">FETCH</code> (R)</p></li><li class="listitem"><p><code class="literal">FIELDS</code></p></li><li class="listitem"><p><code class="literal">FILE</code></p></li><li class="listitem"><p><code class="literal">FILE_BLOCK_SIZE</code></p></li><li class="listitem"><p><code class="literal">FILTER</code></p></li><li class="listitem"><p><code class="literal">FIRST</code></p></li><li class="listitem"><p><code class="literal">FIRST_VALUE</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">FIXED</code></p></li><li class="listitem"><p><code class="literal">FLOAT</code> (R)</p></li><li class="listitem"><p><code class="literal">FLOAT4</code> (R)</p></li><li class="listitem"><p><code class="literal">FLOAT8</code> (R)</p></li><li class="listitem"><p><code class="literal">FLUSH</code></p></li><li class="listitem"><p><code class="literal">FOLLOWING</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">FOLLOWS</code></p></li><li class="listitem"><p><code class="literal">FOR</code> (R)</p></li><li class="listitem"><p><code class="literal">FORCE</code> (R)</p></li><li class="listitem"><p><code class="literal">FOREIGN</code> (R)</p></li><li class="listitem"><p><code class="literal">FORMAT</code></p></li><li class="listitem"><p><code class="literal">FOUND</code></p></li><li class="listitem"><p><code class="literal">FROM</code> (R)</p></li><li class="listitem"><p><code class="literal">FULL</code></p></li><li class="listitem"><p><code class="literal">FULLTEXT</code> (R)</p></li><li class="listitem"><p><code class="literal">FUNCTION</code> (R); became reserved in 8.0.1</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-G"></a>G</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">GENERAL</code></p></li><li class="listitem"><p><code class="literal">GENERATED</code> (R)</p></li><li class="listitem"><p><code class="literal">GEOMCOLLECTION</code>; added in 8.0.11 (nonreserved)</p></li><li class="listitem"><p><code class="literal">GEOMETRY</code></p></li><li class="listitem"><p><code class="literal">GEOMETRYCOLLECTION</code></p></li><li class="listitem"><p><code class="literal">GET</code> (R)</p></li><li class="listitem"><p><code class="literal">GET_FORMAT</code></p></li><li class="listitem"><p><code class="literal">GET_MASTER_PUBLIC_KEY</code>; added in 8.0.4 (reserved); became nonreserved in 8.0.11</p></li><li class="listitem"><p><code class="literal">GLOBAL</code></p></li><li class="listitem"><p><code class="literal">GRANT</code> (R)</p></li><li class="listitem"><p><code class="literal">GRANTS</code></p></li><li class="listitem"><p><code class="literal">GROUP</code> (R)</p></li><li class="listitem"><p><code class="literal">GROUPING</code> (R); added in 8.0.1 (reserved)</p></li><li class="listitem"><p><code class="literal">GROUPS</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">GROUP_REPLICATION</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-H"></a>H</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">HANDLER</code></p></li><li class="listitem"><p><code class="literal">HASH</code></p></li><li class="listitem"><p><code class="literal">HAVING</code> (R)</p></li><li class="listitem"><p><code class="literal">HELP</code></p></li><li class="listitem"><p><code class="literal">HIGH_PRIORITY</code> (R)</p></li><li class="listitem"><p><code class="literal">HISTOGRAM</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">HISTORY</code>; added in 8.0.3 (nonreserved)</p></li><li class="listitem"><p><code class="literal">HOST</code></p></li><li class="listitem"><p><code class="literal">HOSTS</code></p></li><li class="listitem"><p><code class="literal">HOUR</code></p></li><li class="listitem"><p><code class="literal">HOUR_MICROSECOND</code> (R)</p></li><li class="listitem"><p><code class="literal">HOUR_MINUTE</code> (R)</p></li><li class="listitem"><p><code class="literal">HOUR_SECOND</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-I"></a>I</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">IDENTIFIED</code></p></li><li class="listitem"><p><code class="literal">IF</code> (R)</p></li><li class="listitem"><p><code class="literal">IGNORE</code> (R)</p></li><li class="listitem"><p><code class="literal">IGNORE_SERVER_IDS</code></p></li><li class="listitem"><p><code class="literal">IMPORT</code></p></li><li class="listitem"><p><code class="literal">IN</code> (R)</p></li><li class="listitem"><p><code class="literal">INACTIVE</code>; added in 8.0.14 (nonreserved)</p></li><li class="listitem"><p><code class="literal">INDEX</code> (R)</p></li><li class="listitem"><p><code class="literal">INDEXES</code></p></li><li class="listitem"><p><code class="literal">INFILE</code> (R)</p></li><li class="listitem"><p><code class="literal">INITIAL_SIZE</code></p></li><li class="listitem"><p><code class="literal">INNER</code> (R)</p></li><li class="listitem"><p><code class="literal">INOUT</code> (R)</p></li><li class="listitem"><p><code class="literal">INSENSITIVE</code> (R)</p></li><li class="listitem"><p><code class="literal">INSERT</code> (R)</p></li><li class="listitem"><p><code class="literal">INSERT_METHOD</code></p></li><li class="listitem"><p><code class="literal">INSTALL</code></p></li><li class="listitem"><p><code class="literal">INSTANCE</code></p></li><li class="listitem"><p><code class="literal">INT</code> (R)</p></li><li class="listitem"><p><code class="literal">INT1</code> (R)</p></li><li class="listitem"><p><code class="literal">INT2</code> (R)</p></li><li class="listitem"><p><code class="literal">INT3</code> (R)</p></li><li class="listitem"><p><code class="literal">INT4</code> (R)</p></li><li class="listitem"><p><code class="literal">INT8</code> (R)</p></li><li class="listitem"><p><code class="literal">INTEGER</code> (R)</p></li><li class="listitem"><p><code class="literal">INTERVAL</code> (R)</p></li><li class="listitem"><p><code class="literal">INTO</code> (R)</p></li><li class="listitem"><p><code class="literal">INVISIBLE</code></p></li><li class="listitem"><p><code class="literal">INVOKER</code></p></li><li class="listitem"><p><code class="literal">IO</code></p></li><li class="listitem"><p><code class="literal">IO_AFTER_GTIDS</code> (R)</p></li><li class="listitem"><p><code class="literal">IO_BEFORE_GTIDS</code> (R)</p></li><li class="listitem"><p><code class="literal">IO_THREAD</code></p></li><li class="listitem"><p><code class="literal">IPC</code></p></li><li class="listitem"><p><code class="literal">IS</code> (R)</p></li><li class="listitem"><p><code class="literal">ISOLATION</code></p></li><li class="listitem"><p><code class="literal">ISSUER</code></p></li><li class="listitem"><p><code class="literal">ITERATE</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-J"></a>J</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">JOIN</code> (R)</p></li><li class="listitem"><p><code class="literal">JSON</code></p></li><li class="listitem"><p><code class="literal">JSON_TABLE</code> (R); added in 8.0.4 (reserved)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-K"></a>K</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">KEY</code> (R)</p></li><li class="listitem"><p><code class="literal">KEYS</code> (R)</p></li><li class="listitem"><p><code class="literal">KEY_BLOCK_SIZE</code></p></li><li class="listitem"><p><code class="literal">KILL</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-L"></a>L</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">LAG</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">LANGUAGE</code></p></li><li class="listitem"><p><code class="literal">LAST</code></p></li><li class="listitem"><p><code class="literal">LAST_VALUE</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">LATERAL</code> (R); added in 8.0.14 (reserved)</p></li><li class="listitem"><p><code class="literal">LEAD</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">LEADING</code> (R)</p></li><li class="listitem"><p><code class="literal">LEAVE</code> (R)</p></li><li class="listitem"><p><code class="literal">LEAVES</code></p></li><li class="listitem"><p><code class="literal">LEFT</code> (R)</p></li><li class="listitem"><p><code class="literal">LESS</code></p></li><li class="listitem"><p><code class="literal">LEVEL</code></p></li><li class="listitem"><p><code class="literal">LIKE</code> (R)</p></li><li class="listitem"><p><code class="literal">LIMIT</code> (R)</p></li><li class="listitem"><p><code class="literal">LINEAR</code> (R)</p></li><li class="listitem"><p><code class="literal">LINES</code> (R)</p></li><li class="listitem"><p><code class="literal">LINESTRING</code></p></li><li class="listitem"><p><code class="literal">LIST</code></p></li><li class="listitem"><p><code class="literal">LOAD</code> (R)</p></li><li class="listitem"><p><code class="literal">LOCAL</code></p></li><li class="listitem"><p><code class="literal">LOCALTIME</code> (R)</p></li><li class="listitem"><p><code class="literal">LOCALTIMESTAMP</code> (R)</p></li><li class="listitem"><p><code class="literal">LOCK</code> (R)</p></li><li class="listitem"><p><code class="literal">LOCKED</code>; added in 8.0.1 (nonreserved)</p></li><li class="listitem"><p><code class="literal">LOCKS</code></p></li><li class="listitem"><p><code class="literal">LOGFILE</code></p></li><li class="listitem"><p><code class="literal">LOGS</code></p></li><li class="listitem"><p><code class="literal">LONG</code> (R)</p></li><li class="listitem"><p><code class="literal">LONGBLOB</code> (R)</p></li><li class="listitem"><p><code class="literal">LONGTEXT</code> (R)</p></li><li class="listitem"><p><code class="literal">LOOP</code> (R)</p></li><li class="listitem"><p><code class="literal">LOW_PRIORITY</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-M"></a>M</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">MASTER</code></p></li><li class="listitem"><p><code class="literal">MASTER_AUTO_POSITION</code></p></li><li class="listitem"><p><code class="literal">MASTER_BIND</code> (R)</p></li><li class="listitem"><p><code class="literal">MASTER_CONNECT_RETRY</code></p></li><li class="listitem"><p><code class="literal">MASTER_DELAY</code></p></li><li class="listitem"><p><code class="literal">MASTER_HEARTBEAT_PERIOD</code></p></li><li class="listitem"><p><code class="literal">MASTER_HOST</code></p></li><li class="listitem"><p><code class="literal">MASTER_LOG_FILE</code></p></li><li class="listitem"><p><code class="literal">MASTER_LOG_POS</code></p></li><li class="listitem"><p><code class="literal">MASTER_PASSWORD</code></p></li><li class="listitem"><p><code class="literal">MASTER_PORT</code></p></li><li class="listitem"><p><code class="literal">MASTER_PUBLIC_KEY_PATH</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">MASTER_RETRY_COUNT</code></p></li><li class="listitem"><p><code class="literal">MASTER_SERVER_ID</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_CA</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_CAPATH</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_CERT</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_CIPHER</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_CRL</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_CRLPATH</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_KEY</code></p></li><li class="listitem"><p><code class="literal">MASTER_SSL_VERIFY_SERVER_CERT</code> (R)</p></li><li class="listitem"><p><code class="literal">MASTER_TLS_VERSION</code></p></li><li class="listitem"><p><code class="literal">MASTER_USER</code></p></li><li class="listitem"><p><code class="literal">MATCH</code> (R)</p></li><li class="listitem"><p><code class="literal">MAXVALUE</code> (R)</p></li><li class="listitem"><p><code class="literal">MAX_CONNECTIONS_PER_HOUR</code></p></li><li class="listitem"><p><code class="literal">MAX_QUERIES_PER_HOUR</code></p></li><li class="listitem"><p><code class="literal">MAX_ROWS</code></p></li><li class="listitem"><p><code class="literal">MAX_SIZE</code></p></li><li class="listitem"><p><code class="literal">MAX_UPDATES_PER_HOUR</code></p></li><li class="listitem"><p><code class="literal">MAX_USER_CONNECTIONS</code></p></li><li class="listitem"><p><code class="literal">MEDIUM</code></p></li><li class="listitem"><p><code class="literal">MEDIUMBLOB</code> (R)</p></li><li class="listitem"><p><code class="literal">MEDIUMINT</code> (R)</p></li><li class="listitem"><p><code class="literal">MEDIUMTEXT</code> (R)</p></li><li class="listitem"><p><code class="literal">MEMBER</code> (R); added in 8.0.17 (reserved)</p></li><li class="listitem"><p><code class="literal">MEMORY</code></p></li><li class="listitem"><p><code class="literal">MERGE</code></p></li><li class="listitem"><p><code class="literal">MESSAGE_TEXT</code></p></li><li class="listitem"><p><code class="literal">MICROSECOND</code></p></li><li class="listitem"><p><code class="literal">MIDDLEINT</code> (R)</p></li><li class="listitem"><p><code class="literal">MIGRATE</code></p></li><li class="listitem"><p><code class="literal">MINUTE</code></p></li><li class="listitem"><p><code class="literal">MINUTE_MICROSECOND</code> (R)</p></li><li class="listitem"><p><code class="literal">MINUTE_SECOND</code> (R)</p></li><li class="listitem"><p><code class="literal">MIN_ROWS</code></p></li><li class="listitem"><p><code class="literal">MOD</code> (R)</p></li><li class="listitem"><p><code class="literal">MODE</code></p></li><li class="listitem"><p><code class="literal">MODIFIES</code> (R)</p></li><li class="listitem"><p><code class="literal">MODIFY</code></p></li><li class="listitem"><p><code class="literal">MONTH</code></p></li><li class="listitem"><p><code class="literal">MULTILINESTRING</code></p></li><li class="listitem"><p><code class="literal">MULTIPOINT</code></p></li><li class="listitem"><p><code class="literal">MULTIPOLYGON</code></p></li><li class="listitem"><p><code class="literal">MUTEX</code></p></li><li class="listitem"><p><code class="literal">MYSQL_ERRNO</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-N"></a>N</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">NAME</code></p></li><li class="listitem"><p><code class="literal">NAMES</code></p></li><li class="listitem"><p><code class="literal">NATIONAL</code></p></li><li class="listitem"><p><code class="literal">NATURAL</code> (R)</p></li><li class="listitem"><p><code class="literal">NCHAR</code></p></li><li class="listitem"><p><code class="literal">NDB</code></p></li><li class="listitem"><p><code class="literal">NDBCLUSTER</code></p></li><li class="listitem"><p><code class="literal">NESTED</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">NETWORK_NAMESPACE</code>; added in 8.0.16 (nonreserved)</p></li><li class="listitem"><p><code class="literal">NEVER</code></p></li><li class="listitem"><p><code class="literal">NEW</code></p></li><li class="listitem"><p><code class="literal">NEXT</code></p></li><li class="listitem"><p><code class="literal">NO</code></p></li><li class="listitem"><p><code class="literal">NODEGROUP</code></p></li><li class="listitem"><p><code class="literal">NONE</code></p></li><li class="listitem"><p><code class="literal">NOT</code> (R)</p></li><li class="listitem"><p><code class="literal">NOWAIT</code>; added in 8.0.1 (nonreserved)</p></li><li class="listitem"><p><code class="literal">NO_WAIT</code></p></li><li class="listitem"><p><code class="literal">NO_WRITE_TO_BINLOG</code> (R)</p></li><li class="listitem"><p><code class="literal">NTH_VALUE</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">NTILE</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">NULL</code> (R)</p></li><li class="listitem"><p><code class="literal">NULLS</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">NUMBER</code></p></li><li class="listitem"><p><code class="literal">NUMERIC</code> (R)</p></li><li class="listitem"><p><code class="literal">NVARCHAR</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-O"></a>O</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">OF</code> (R); added in 8.0.1 (reserved)</p></li><li class="listitem"><p><code class="literal">OFFSET</code></p></li><li class="listitem"><p><code class="literal">OJ</code>; added in 8.0.16 (nonreserved)</p></li><li class="listitem"><p><code class="literal">OLD</code>; added in 8.0.14 (nonreserved)</p></li><li class="listitem"><p><code class="literal">ON</code> (R)</p></li><li class="listitem"><p><code class="literal">ONE</code></p></li><li class="listitem"><p><code class="literal">ONLY</code></p></li><li class="listitem"><p><code class="literal">OPEN</code></p></li><li class="listitem"><p><code class="literal">OPTIMIZE</code> (R)</p></li><li class="listitem"><p><code class="literal">OPTIMIZER_COSTS</code> (R)</p></li><li class="listitem"><p><code class="literal">OPTION</code> (R)</p></li><li class="listitem"><p><code class="literal">OPTIONAL</code>; added in 8.0.13 (nonreserved)</p></li><li class="listitem"><p><code class="literal">OPTIONALLY</code> (R)</p></li><li class="listitem"><p><code class="literal">OPTIONS</code></p></li><li class="listitem"><p><code class="literal">OR</code> (R)</p></li><li class="listitem"><p><code class="literal">ORDER</code> (R)</p></li><li class="listitem"><p><code class="literal">ORDINALITY</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">ORGANIZATION</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">OTHERS</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">OUT</code> (R)</p></li><li class="listitem"><p><code class="literal">OUTER</code> (R)</p></li><li class="listitem"><p><code class="literal">OUTFILE</code> (R)</p></li><li class="listitem"><p><code class="literal">OVER</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">OWNER</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-P"></a>P</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">PACK_KEYS</code></p></li><li class="listitem"><p><code class="literal">PAGE</code></p></li><li class="listitem"><p><code class="literal">PARSER</code></p></li><li class="listitem"><p><code class="literal">PARTIAL</code></p></li><li class="listitem"><p><code class="literal">PARTITION</code> (R)</p></li><li class="listitem"><p><code class="literal">PARTITIONING</code></p></li><li class="listitem"><p><code class="literal">PARTITIONS</code></p></li><li class="listitem"><p><code class="literal">PASSWORD</code></p></li><li class="listitem"><p><code class="literal">PATH</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">PERCENT_RANK</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">PERSIST</code>; became nonreserved in 8.0.16</p></li><li class="listitem"><p><code class="literal">PERSIST_ONLY</code>; added in 8.0.2 (reserved); became nonreserved in 8.0.16</p></li><li class="listitem"><p><code class="literal">PHASE</code></p></li><li class="listitem"><p><code class="literal">PLUGIN</code></p></li><li class="listitem"><p><code class="literal">PLUGINS</code></p></li><li class="listitem"><p><code class="literal">PLUGIN_DIR</code></p></li><li class="listitem"><p><code class="literal">POINT</code></p></li><li class="listitem"><p><code class="literal">POLYGON</code></p></li><li class="listitem"><p><code class="literal">PORT</code></p></li><li class="listitem"><p><code class="literal">PRECEDES</code></p></li><li class="listitem"><p><code class="literal">PRECEDING</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">PRECISION</code> (R)</p></li><li class="listitem"><p><code class="literal">PREPARE</code></p></li><li class="listitem"><p><code class="literal">PRESERVE</code></p></li><li class="listitem"><p><code class="literal">PREV</code></p></li><li class="listitem"><p><code class="literal">PRIMARY</code> (R)</p></li><li class="listitem"><p><code class="literal">PRIVILEGES</code></p></li><li class="listitem"><p><code class="literal">PROCEDURE</code> (R)</p></li><li class="listitem"><p><code class="literal">PROCESS</code>; added in 8.0.11 (nonreserved)</p></li><li class="listitem"><p><code class="literal">PROCESSLIST</code></p></li><li class="listitem"><p><code class="literal">PROFILE</code></p></li><li class="listitem"><p><code class="literal">PROFILES</code></p></li><li class="listitem"><p><code class="literal">PROXY</code></p></li><li class="listitem"><p><code class="literal">PURGE</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-Q"></a>Q</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">QUARTER</code></p></li><li class="listitem"><p><code class="literal">QUERY</code></p></li><li class="listitem"><p><code class="literal">QUICK</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-R"></a>R</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">RANGE</code> (R)</p></li><li class="listitem"><p><code class="literal">RANK</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">READ</code> (R)</p></li><li class="listitem"><p><code class="literal">READS</code> (R)</p></li><li class="listitem"><p><code class="literal">READ_ONLY</code></p></li><li class="listitem"><p><code class="literal">READ_WRITE</code> (R)</p></li><li class="listitem"><p><code class="literal">REAL</code> (R)</p></li><li class="listitem"><p><code class="literal">REBUILD</code></p></li><li class="listitem"><p><code class="literal">RECOVER</code></p></li><li class="listitem"><p><code class="literal">RECURSIVE</code> (R); added in 8.0.1 (reserved)</p></li><li class="listitem"><p><code class="literal">REDOFILE</code>; removed in 8.0.3</p></li><li class="listitem"><p><code class="literal">REDO_BUFFER_SIZE</code></p></li><li class="listitem"><p><code class="literal">REDUNDANT</code></p></li><li class="listitem"><p><code class="literal">REFERENCE</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">REFERENCES</code> (R)</p></li><li class="listitem"><p><code class="literal">REGEXP</code> (R)</p></li><li class="listitem"><p><code class="literal">RELAY</code></p></li><li class="listitem"><p><code class="literal">RELAYLOG</code></p></li><li class="listitem"><p><code class="literal">RELAY_LOG_FILE</code></p></li><li class="listitem"><p><code class="literal">RELAY_LOG_POS</code></p></li><li class="listitem"><p><code class="literal">RELAY_THREAD</code></p></li><li class="listitem"><p><code class="literal">RELEASE</code> (R)</p></li><li class="listitem"><p><code class="literal">RELOAD</code></p></li><li class="listitem"><p><code class="literal">REMOTE</code>; added in 8.0.3 (nonreserved); removed in 8.0.14</p></li><li class="listitem"><p><code class="literal">REMOVE</code></p></li><li class="listitem"><p><code class="literal">RENAME</code> (R)</p></li><li class="listitem"><p><code class="literal">REORGANIZE</code></p></li><li class="listitem"><p><code class="literal">REPAIR</code></p></li><li class="listitem"><p><code class="literal">REPEAT</code> (R)</p></li><li class="listitem"><p><code class="literal">REPEATABLE</code></p></li><li class="listitem"><p><code class="literal">REPLACE</code> (R)</p></li><li class="listitem"><p><code class="literal">REPLICATE_DO_DB</code></p></li><li class="listitem"><p><code class="literal">REPLICATE_DO_TABLE</code></p></li><li class="listitem"><p><code class="literal">REPLICATE_IGNORE_DB</code></p></li><li class="listitem"><p><code class="literal">REPLICATE_IGNORE_TABLE</code></p></li><li class="listitem"><p><code class="literal">REPLICATE_REWRITE_DB</code></p></li><li class="listitem"><p><code class="literal">REPLICATE_WILD_DO_TABLE</code></p></li><li class="listitem"><p><code class="literal">REPLICATE_WILD_IGNORE_TABLE</code></p></li><li class="listitem"><p><code class="literal">REPLICATION</code></p></li><li class="listitem"><p><code class="literal">REQUIRE</code> (R)</p></li><li class="listitem"><p><code class="literal">RESET</code></p></li><li class="listitem"><p><code class="literal">RESIGNAL</code> (R)</p></li><li class="listitem"><p><code class="literal">RESOURCE</code>; added in 8.0.3 (nonreserved)</p></li><li class="listitem"><p><code class="literal">RESPECT</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">RESTART</code>; added in 8.0.4 (nonreserved)</p></li><li class="listitem"><p><code class="literal">RESTORE</code></p></li><li class="listitem"><p><code class="literal">RESTRICT</code> (R)</p></li><li class="listitem"><p><code class="literal">RESUME</code></p></li><li class="listitem"><p><code class="literal">RETAIN</code>; added in 8.0.14 (nonreserved)</p></li><li class="listitem"><p><code class="literal">RETURN</code> (R)</p></li><li class="listitem"><p><code class="literal">RETURNED_SQLSTATE</code></p></li><li class="listitem"><p><code class="literal">RETURNS</code></p></li><li class="listitem"><p><code class="literal">REUSE</code>; added in 8.0.3 (nonreserved)</p></li><li class="listitem"><p><code class="literal">REVERSE</code></p></li><li class="listitem"><p><code class="literal">REVOKE</code> (R)</p></li><li class="listitem"><p><code class="literal">RIGHT</code> (R)</p></li><li class="listitem"><p><code class="literal">RLIKE</code> (R)</p></li><li class="listitem"><p><code class="literal">ROLE</code>; became nonreserved in 8.0.1</p></li><li class="listitem"><p><code class="literal">ROLLBACK</code></p></li><li class="listitem"><p><code class="literal">ROLLUP</code></p></li><li class="listitem"><p><code class="literal">ROTATE</code></p></li><li class="listitem"><p><code class="literal">ROUTINE</code></p></li><li class="listitem"><p><code class="literal">ROW</code> (R); became reserved in 8.0.2</p></li><li class="listitem"><p><code class="literal">ROWS</code> (R); became reserved in 8.0.2</p></li><li class="listitem"><p><code class="literal">ROW_COUNT</code></p></li><li class="listitem"><p><code class="literal">ROW_FORMAT</code></p></li><li class="listitem"><p><code class="literal">ROW_NUMBER</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">RTREE</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-S"></a>S</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">SAVEPOINT</code></p></li><li class="listitem"><p><code class="literal">SCHEDULE</code></p></li><li class="listitem"><p><code class="literal">SCHEMA</code> (R)</p></li><li class="listitem"><p><code class="literal">SCHEMAS</code> (R)</p></li><li class="listitem"><p><code class="literal">SCHEMA_NAME</code></p></li><li class="listitem"><p><code class="literal">SECOND</code></p></li><li class="listitem"><p><code class="literal">SECONDARY</code>; added in 8.0.16 (nonreserved)</p></li><li class="listitem"><p><code class="literal">SECONDARY_ENGINE</code>; added in 8.0.13 (nonreserved)</p></li><li class="listitem"><p><code class="literal">SECONDARY_LOAD</code>; added in 8.0.13 (nonreserved)</p></li><li class="listitem"><p><code class="literal">SECONDARY_UNLOAD</code>; added in 8.0.13 (nonreserved)</p></li><li class="listitem"><p><code class="literal">SECOND_MICROSECOND</code> (R)</p></li><li class="listitem"><p><code class="literal">SECURITY</code></p></li><li class="listitem"><p><code class="literal">SELECT</code> (R)</p></li><li class="listitem"><p><code class="literal">SENSITIVE</code> (R)</p></li><li class="listitem"><p><code class="literal">SEPARATOR</code> (R)</p></li><li class="listitem"><p><code class="literal">SERIAL</code></p></li><li class="listitem"><p><code class="literal">SERIALIZABLE</code></p></li><li class="listitem"><p><code class="literal">SERVER</code></p></li><li class="listitem"><p><code class="literal">SESSION</code></p></li><li class="listitem"><p><code class="literal">SET</code> (R)</p></li><li class="listitem"><p><code class="literal">SHARE</code></p></li><li class="listitem"><p><code class="literal">SHOW</code> (R)</p></li><li class="listitem"><p><code class="literal">SHUTDOWN</code></p></li><li class="listitem"><p><code class="literal">SIGNAL</code> (R)</p></li><li class="listitem"><p><code class="literal">SIGNED</code></p></li><li class="listitem"><p><code class="literal">SIMPLE</code></p></li><li class="listitem"><p><code class="literal">SKIP</code>; added in 8.0.1 (nonreserved)</p></li><li class="listitem"><p><code class="literal">SLAVE</code></p></li><li class="listitem"><p><code class="literal">SLOW</code></p></li><li class="listitem"><p><code class="literal">SMALLINT</code> (R)</p></li><li class="listitem"><p><code class="literal">SNAPSHOT</code></p></li><li class="listitem"><p><code class="literal">SOCKET</code></p></li><li class="listitem"><p><code class="literal">SOME</code></p></li><li class="listitem"><p><code class="literal">SONAME</code></p></li><li class="listitem"><p><code class="literal">SOUNDS</code></p></li><li class="listitem"><p><code class="literal">SOURCE</code></p></li><li class="listitem"><p><code class="literal">SPATIAL</code> (R)</p></li><li class="listitem"><p><code class="literal">SPECIFIC</code> (R)</p></li><li class="listitem"><p><code class="literal">SQL</code> (R)</p></li><li class="listitem"><p><code class="literal">SQLEXCEPTION</code> (R)</p></li><li class="listitem"><p><code class="literal">SQLSTATE</code> (R)</p></li><li class="listitem"><p><code class="literal">SQLWARNING</code> (R)</p></li><li class="listitem"><p><code class="literal">SQL_AFTER_GTIDS</code></p></li><li class="listitem"><p><code class="literal">SQL_AFTER_MTS_GAPS</code></p></li><li class="listitem"><p><code class="literal">SQL_BEFORE_GTIDS</code></p></li><li class="listitem"><p><code class="literal">SQL_BIG_RESULT</code> (R)</p></li><li class="listitem"><p><code class="literal">SQL_BUFFER_RESULT</code></p></li><li class="listitem"><p><code class="literal">SQL_CACHE</code>; removed in 8.0.3</p></li><li class="listitem"><p><code class="literal">SQL_CALC_FOUND_ROWS</code> (R)</p></li><li class="listitem"><p><code class="literal">SQL_NO_CACHE</code></p></li><li class="listitem"><p><code class="literal">SQL_SMALL_RESULT</code> (R)</p></li><li class="listitem"><p><code class="literal">SQL_THREAD</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_DAY</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_HOUR</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_MINUTE</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_MONTH</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_QUARTER</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_SECOND</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_WEEK</code></p></li><li class="listitem"><p><code class="literal">SQL_TSI_YEAR</code></p></li><li class="listitem"><p><code class="literal">SRID</code>; added in 8.0.3 (nonreserved)</p></li><li class="listitem"><p><code class="literal">SSL</code> (R)</p></li><li class="listitem"><p><code class="literal">STACKED</code></p></li><li class="listitem"><p><code class="literal">START</code></p></li><li class="listitem"><p><code class="literal">STARTING</code> (R)</p></li><li class="listitem"><p><code class="literal">STARTS</code></p></li><li class="listitem"><p><code class="literal">STATS_AUTO_RECALC</code></p></li><li class="listitem"><p><code class="literal">STATS_PERSISTENT</code></p></li><li class="listitem"><p><code class="literal">STATS_SAMPLE_PAGES</code></p></li><li class="listitem"><p><code class="literal">STATUS</code></p></li><li class="listitem"><p><code class="literal">STOP</code></p></li><li class="listitem"><p><code class="literal">STORAGE</code></p></li><li class="listitem"><p><code class="literal">STORED</code> (R)</p></li><li class="listitem"><p><code class="literal">STRAIGHT_JOIN</code> (R)</p></li><li class="listitem"><p><code class="literal">STRING</code></p></li><li class="listitem"><p><code class="literal">SUBCLASS_ORIGIN</code></p></li><li class="listitem"><p><code class="literal">SUBJECT</code></p></li><li class="listitem"><p><code class="literal">SUBPARTITION</code></p></li><li class="listitem"><p><code class="literal">SUBPARTITIONS</code></p></li><li class="listitem"><p><code class="literal">SUPER</code></p></li><li class="listitem"><p><code class="literal">SUSPEND</code></p></li><li class="listitem"><p><code class="literal">SWAPS</code></p></li><li class="listitem"><p><code class="literal">SWITCHES</code></p></li><li class="listitem"><p><code class="literal">SYSTEM</code> (R); added in 8.0.3 (reserved)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-T"></a>T</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">TABLE</code> (R)</p></li><li class="listitem"><p><code class="literal">TABLES</code></p></li><li class="listitem"><p><code class="literal">TABLESPACE</code></p></li><li class="listitem"><p><code class="literal">TABLE_CHECKSUM</code></p></li><li class="listitem"><p><code class="literal">TABLE_NAME</code></p></li><li class="listitem"><p><code class="literal">TEMPORARY</code></p></li><li class="listitem"><p><code class="literal">TEMPTABLE</code></p></li><li class="listitem"><p><code class="literal">TERMINATED</code> (R)</p></li><li class="listitem"><p><code class="literal">TEXT</code></p></li><li class="listitem"><p><code class="literal">THAN</code></p></li><li class="listitem"><p><code class="literal">THEN</code> (R)</p></li><li class="listitem"><p><code class="literal">THREAD_PRIORITY</code>; added in 8.0.3 (nonreserved)</p></li><li class="listitem"><p><code class="literal">TIES</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">TIME</code></p></li><li class="listitem"><p><code class="literal">TIMESTAMP</code></p></li><li class="listitem"><p><code class="literal">TIMESTAMPADD</code></p></li><li class="listitem"><p><code class="literal">TIMESTAMPDIFF</code></p></li><li class="listitem"><p><code class="literal">TINYBLOB</code> (R)</p></li><li class="listitem"><p><code class="literal">TINYINT</code> (R)</p></li><li class="listitem"><p><code class="literal">TINYTEXT</code> (R)</p></li><li class="listitem"><p><code class="literal">TO</code> (R)</p></li><li class="listitem"><p><code class="literal">TRAILING</code> (R)</p></li><li class="listitem"><p><code class="literal">TRANSACTION</code></p></li><li class="listitem"><p><code class="literal">TRIGGER</code> (R)</p></li><li class="listitem"><p><code class="literal">TRIGGERS</code></p></li><li class="listitem"><p><code class="literal">TRUE</code> (R)</p></li><li class="listitem"><p><code class="literal">TRUNCATE</code></p></li><li class="listitem"><p><code class="literal">TYPE</code></p></li><li class="listitem"><p><code class="literal">TYPES</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-U"></a>U</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">UNBOUNDED</code>; added in 8.0.2 (nonreserved)</p></li><li class="listitem"><p><code class="literal">UNCOMMITTED</code></p></li><li class="listitem"><p><code class="literal">UNDEFINED</code></p></li><li class="listitem"><p><code class="literal">UNDO</code> (R)</p></li><li class="listitem"><p><code class="literal">UNDOFILE</code></p></li><li class="listitem"><p><code class="literal">UNDO_BUFFER_SIZE</code></p></li><li class="listitem"><p><code class="literal">UNICODE</code></p></li><li class="listitem"><p><code class="literal">UNINSTALL</code></p></li><li class="listitem"><p><code class="literal">UNION</code> (R)</p></li><li class="listitem"><p><code class="literal">UNIQUE</code> (R)</p></li><li class="listitem"><p><code class="literal">UNKNOWN</code></p></li><li class="listitem"><p><code class="literal">UNLOCK</code> (R)</p></li><li class="listitem"><p><code class="literal">UNSIGNED</code> (R)</p></li><li class="listitem"><p><code class="literal">UNTIL</code></p></li><li class="listitem"><p><code class="literal">UPDATE</code> (R)</p></li><li class="listitem"><p><code class="literal">UPGRADE</code></p></li><li class="listitem"><p><code class="literal">USAGE</code> (R)</p></li><li class="listitem"><p><code class="literal">USE</code> (R)</p></li><li class="listitem"><p><code class="literal">USER</code></p></li><li class="listitem"><p><code class="literal">USER_RESOURCES</code></p></li><li class="listitem"><p><code class="literal">USE_FRM</code></p></li><li class="listitem"><p><code class="literal">USING</code> (R)</p></li><li class="listitem"><p><code class="literal">UTC_DATE</code> (R)</p></li><li class="listitem"><p><code class="literal">UTC_TIME</code> (R)</p></li><li class="listitem"><p><code class="literal">UTC_TIMESTAMP</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-V"></a>V</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">VALIDATION</code></p></li><li class="listitem"><p><code class="literal">VALUE</code></p></li><li class="listitem"><p><code class="literal">VALUES</code> (R)</p></li><li class="listitem"><p><code class="literal">VARBINARY</code> (R)</p></li><li class="listitem"><p><code class="literal">VARCHAR</code> (R)</p></li><li class="listitem"><p><code class="literal">VARCHARACTER</code> (R)</p></li><li class="listitem"><p><code class="literal">VARIABLES</code></p></li><li class="listitem"><p><code class="literal">VARYING</code> (R)</p></li><li class="listitem"><p><code class="literal">VCPU</code>; added in 8.0.3 (nonreserved)</p></li><li class="listitem"><p><code class="literal">VIEW</code></p></li><li class="listitem"><p><code class="literal">VIRTUAL</code> (R)</p></li><li class="listitem"><p><code class="literal">VISIBLE</code></p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-W"></a>W</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">WAIT</code></p></li><li class="listitem"><p><code class="literal">WARNINGS</code></p></li><li class="listitem"><p><code class="literal">WEEK</code></p></li><li class="listitem"><p><code class="literal">WEIGHT_STRING</code></p></li><li class="listitem"><p><code class="literal">WHEN</code> (R)</p></li><li class="listitem"><p><code class="literal">WHERE</code> (R)</p></li><li class="listitem"><p><code class="literal">WHILE</code> (R)</p></li><li class="listitem"><p><code class="literal">WINDOW</code> (R); added in 8.0.2 (reserved)</p></li><li class="listitem"><p><code class="literal">WITH</code> (R)</p></li><li class="listitem"><p><code class="literal">WITHOUT</code></p></li><li class="listitem"><p><code class="literal">WORK</code></p></li><li class="listitem"><p><code class="literal">WRAPPER</code></p></li><li class="listitem"><p><code class="literal">WRITE</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-X"></a>X</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">X509</code></p></li><li class="listitem"><p><code class="literal">XA</code></p></li><li class="listitem"><p><code class="literal">XID</code></p></li><li class="listitem"><p><code class="literal">XML</code></p></li><li class="listitem"><p><code class="literal">XOR</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-Y"></a>Y</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">YEAR</code></p></li><li class="listitem"><p><code class="literal">YEAR_MONTH</code> (R)</p></li></ul>
</div>
<p><a name="keywords-8-0-detailed-Z"></a>Z</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">ZEROFILL</code> (R)</p></li></ul>
</div>

</div>

<div class="simplesect">

<div class="titlepage">
<div>

<div class="simple">
<h3 class="title"><a name="keywords-new-in-current-series"></a>MySQL 8.0 New Keywords and Reserved Words</h3>

</div>

</div>

</div>
<p>
        The following list shows the keywords and reserved words that
        are added in MySQL 8.0, compared to MySQL
        5.7. Reserved keywords are marked with (R).
      </p><p><a name="keywords-new-8-0-top"></a><a class="link" href="keywords.html#keywords-new-8-0-A">A</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-B">B</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-C">C</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-D">D</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-E">E</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-F">F</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-G">G</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-H">H</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-I">I</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-J">J</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-L">L</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-M">M</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-N">N</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-O">O</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-P">P</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-R">R</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-S">S</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-T">T</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-U">U</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-V">V</a>
 | <a class="link" href="keywords.html#keywords-new-8-0-W">W</a>
</p><p><a name="keywords-new-8-0-A"></a>A</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">ACTIVE</code></p></li><li class="listitem"><p><code class="literal">ADMIN</code></p></li><li class="listitem"><p><code class="literal">ARRAY</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-B"></a>B</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">BUCKETS</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-C"></a>C</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">CLONE</code></p></li><li class="listitem"><p><code class="literal">COMPONENT</code></p></li><li class="listitem"><p><code class="literal">CUME_DIST</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-D"></a>D</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">DEFINITION</code></p></li><li class="listitem"><p><code class="literal">DENSE_RANK</code> (R)</p></li><li class="listitem"><p><code class="literal">DESCRIPTION</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-E"></a>E</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">EMPTY</code> (R)</p></li><li class="listitem"><p><code class="literal">ENFORCED</code></p></li><li class="listitem"><p><code class="literal">EXCEPT</code> (R)</p></li><li class="listitem"><p><code class="literal">EXCLUDE</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-F"></a>F</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">FIRST_VALUE</code> (R)</p></li><li class="listitem"><p><code class="literal">FOLLOWING</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-G"></a>G</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">GEOMCOLLECTION</code></p></li><li class="listitem"><p><code class="literal">GET_MASTER_PUBLIC_KEY</code></p></li><li class="listitem"><p><code class="literal">GROUPING</code> (R)</p></li><li class="listitem"><p><code class="literal">GROUPS</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-H"></a>H</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">HISTOGRAM</code></p></li><li class="listitem"><p><code class="literal">HISTORY</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-I"></a>I</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">INACTIVE</code></p></li><li class="listitem"><p><code class="literal">INVISIBLE</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-J"></a>J</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">JSON_TABLE</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-L"></a>L</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">LAG</code> (R)</p></li><li class="listitem"><p><code class="literal">LAST_VALUE</code> (R)</p></li><li class="listitem"><p><code class="literal">LATERAL</code> (R)</p></li><li class="listitem"><p><code class="literal">LEAD</code> (R)</p></li><li class="listitem"><p><code class="literal">LOCKED</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-M"></a>M</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">MASTER_PUBLIC_KEY_PATH</code></p></li><li class="listitem"><p><code class="literal">MEMBER</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-N"></a>N</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">NESTED</code></p></li><li class="listitem"><p><code class="literal">NETWORK_NAMESPACE</code></p></li><li class="listitem"><p><code class="literal">NOWAIT</code></p></li><li class="listitem"><p><code class="literal">NTH_VALUE</code> (R)</p></li><li class="listitem"><p><code class="literal">NTILE</code> (R)</p></li><li class="listitem"><p><code class="literal">NULLS</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-O"></a>O</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">OF</code> (R)</p></li><li class="listitem"><p><code class="literal">OJ</code></p></li><li class="listitem"><p><code class="literal">OLD</code></p></li><li class="listitem"><p><code class="literal">OPTIONAL</code></p></li><li class="listitem"><p><code class="literal">ORDINALITY</code></p></li><li class="listitem"><p><code class="literal">ORGANIZATION</code></p></li><li class="listitem"><p><code class="literal">OTHERS</code></p></li><li class="listitem"><p><code class="literal">OVER</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-P"></a>P</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">PATH</code></p></li><li class="listitem"><p><code class="literal">PERCENT_RANK</code> (R)</p></li><li class="listitem"><p><code class="literal">PERSIST</code></p></li><li class="listitem"><p><code class="literal">PERSIST_ONLY</code></p></li><li class="listitem"><p><code class="literal">PRECEDING</code></p></li><li class="listitem"><p><code class="literal">PROCESS</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-R"></a>R</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">RANK</code> (R)</p></li><li class="listitem"><p><code class="literal">RECURSIVE</code> (R)</p></li><li class="listitem"><p><code class="literal">REFERENCE</code></p></li><li class="listitem"><p><code class="literal">RESOURCE</code></p></li><li class="listitem"><p><code class="literal">RESPECT</code></p></li><li class="listitem"><p><code class="literal">RESTART</code></p></li><li class="listitem"><p><code class="literal">RETAIN</code></p></li><li class="listitem"><p><code class="literal">REUSE</code></p></li><li class="listitem"><p><code class="literal">ROLE</code></p></li><li class="listitem"><p><code class="literal">ROW_NUMBER</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-S"></a>S</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">SECONDARY</code></p></li><li class="listitem"><p><code class="literal">SECONDARY_ENGINE</code></p></li><li class="listitem"><p><code class="literal">SECONDARY_LOAD</code></p></li><li class="listitem"><p><code class="literal">SECONDARY_UNLOAD</code></p></li><li class="listitem"><p><code class="literal">SKIP</code></p></li><li class="listitem"><p><code class="literal">SRID</code></p></li><li class="listitem"><p><code class="literal">SYSTEM</code> (R)</p></li></ul>
</div>
<p><a name="keywords-new-8-0-T"></a>T</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">THREAD_PRIORITY</code></p></li><li class="listitem"><p><code class="literal">TIES</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-U"></a>U</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">UNBOUNDED</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-V"></a>V</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">VCPU</code></p></li><li class="listitem"><p><code class="literal">VISIBLE</code></p></li></ul>
</div>
<p><a name="keywords-new-8-0-W"></a>W</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">WINDOW</code> (R)</p></li></ul>
</div>

</div>

<div class="simplesect">

<div class="titlepage">
<div>

<div class="simple">
<h3 class="title"><a name="keywords-removed-in-current-series"></a>MySQL 8.0 Removed Keywords and Reserved Words</h3>

</div>

</div>

</div>
<p>
        The following list shows the keywords and reserved words that
        are removed in MySQL 8.0, compared to MySQL
        5.7. Reserved keywords are marked with (R).
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p><code class="literal">ANALYSE</code></p></li><li class="listitem"><p><code class="literal">DES_KEY_FILE</code></p></li><li class="listitem"><p><code class="literal">PARSE_GCOL_EXPR</code></p></li><li class="listitem"><p><code class="literal">REDOFILE</code></p></li><li class="listitem"><p><code class="literal">SQL_CACHE</code></p></li></ul>
</div>

</div>

</div>

<br />
        </div>

                <div id="docs-in-page-nav-container">
            <div id="docs-in-page-nav">
                
    <a href="function-resolution.html"
        aria-label="Previous" title="Previous: Function Name Parsing and Resolution"><span
        class="icon-chevron-left"></span> PREV</a> &nbsp;
<a href="index.html" aria-label="Start" title="Start"> HOME</a> &nbsp;
        <a aria-label="Up" href="language-structure.html" title="Up: Language Structure"> UP</a> &nbsp;
    <a href="user-variables.html" aria-label="Next"
        title="Next: User-Defined Variables">NEXT <span
        class="icon-chevron-right"></span></a>
            </div>
        </div>
        
         <div id="docs-body-extra">
             
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>
         </div>

              </div>
     </div>

</div>

<script>
$(function() {
    var doc = new $.doc({ 'mobile': $.browser.mobile, 'docId': 1, 'highlight': true });
});
</script>
    

            
        </div>
    </div>

    <footer class="collapsed">
        <div id="footer-bottom">
                                    <div id="footer-collapse">
                <a href="" id="expand-footer"
                    aria-label="Expand Footer"
                    title="Expand Footer"><span
                    class="icon-plus-square"></span></a>
            </div>
                        <div class="footer-contact">
                <div id="footer-contact-icon" style="display: none;">
                    <span class="icon-call-phone"></span>
                </div>
                <div id="footer-contact-numbers" style="display: none;">
                    <strong>Contact MySQL Sales</strong><br/>
                    USA/Canada: +1-866-221-0634 &nbsp;
                    (<a href="https://www.mysql.com/about/contact/phone/">More Countries &raquo;</a>)
                </div>
                <div id="footer-contact-copyright" style="display: inline-block;">
                    <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                    &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                </div>
            </div>
            <div class="social-icons">
                <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook-square"></span></a>
                <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter-square"></span></a>
                <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin-square"></span></a>
                <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube-square"></span></a>
            </div>
            <br class="clear" />
        </div>
        <div id="footer-links">

            <div id="footer-nav"></div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/products/">Products</a></li>
                    <li><a href="https://www.mysql.com/cloud/">Oracle MySQL Cloud Service</a></li>
                    <li><a href="https://www.mysql.com/products/enterprise/">MySQL Enterprise Edition</a></li>
                    <li><a href="https://www.mysql.com/products/standard/">MySQL Standard Edition</a></li>
                    <li><a href="https://www.mysql.com/products/classic/">MySQL Classic Edition</a></li>
                    <li><a href="https://www.mysql.com/products/cluster/">MySQL Cluster CGE</a></li>
                    <li><a href="https://www.mysql.com/oem/">MySQL Embedded (OEM/ISV)</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/services/">Services</a></li>
                    <li><a href="https://www.mysql.com/training/">Training</a></li>
                    <li><a href="https://www.mysql.com/certification/">Certification</a></li>
                    <li><a href="https://www.mysql.com/consulting/">Consulting</a></li>
                    <li><a href="https://www.mysql.com/support/">Support</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/downloads/">Downloads</a></li>
                    <li><a href="https://dev.mysql.com/downloads/mysql/">MySQL Community Server</a></li>
                    <li><a href="https://dev.mysql.com/downloads/cluster/">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/downloads/shell/">MySQL Shell</a></li>
                    <li><a href="https://dev.mysql.com/downloads/router/">MySQL Router</a></li>
                    <li><a href="https://dev.mysql.com/downloads/workbench/">MySQL Workbench</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/doc/">Documentation</a></li>
                    <li><a href="https://dev.mysql.com/doc/refman/en/">MySQL Reference Manual</a></li>
                    <li><a href="https://dev.mysql.com/doc/workbench/en/">MySQL Workbench</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-cluster.html">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-connectors.html">MySQL Connectors</a></li>
                    <li><a href="https://dev.mysql.com/doc/#topic">Topic Guides</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/about/">About MySQL</a></li>
                    <li><a href="https://www.mysql.com/about/contact/">Contact Us</a></li>
                                                            <li><a href="https://www.mysql.com/buy-mysql/">How to Buy</a></li>
                    <li><a href="https://www.mysql.com/partners/">Partners</a></li>
                    <li><a href="https://www.mysql.com/about/jobs/">Job Opportunities</a></li>
                    <li><a href="https://www.mysql.com/sitemap.html">Site Map</a></li>
                </ul>
            </div>

            
            <div id="footer-logo">
                <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                <div class="footer-legal-links">
                    <a href="https://www.mysql.com/about/legal/">Legal Policies</a> |
                    <a href="http://www.oracle.com/us/legal/privacy/index.htm">Your Privacy Rights</a> |
                    <a href="http://www.oracle.com/us/legal/terms/index.html">Terms of Use</a> |
                    <a href="http://www.oracle.com/us/legal/third-party-trademarks/index.html">Trademark Policy</a> |
                    <a href="http://www.oracle.com/technetwork/community/oca-486395.html">Contributor Agreement</a> |
                    <div id="teconsent" style="display: inline-block"><script async="async" type="text/javascript" src="js/notice.js" crossorigin=""></script></div>
                </div>
            </div>

        </div>
    </footer>
</div>

        <script src="js/s_code_remote.js"></script>

        
    
</body>
</html>
